import pandas as pd
import pendulum
import 测试类 as ce


past = pendulum.now().subtract(minutes=5)

# Basic.DebugOutput(self, past)
print(pendulum.now())


def test():
    # # 设置行不限制数量
    pd.set_option('display.max_rows', None)
    # # 最后的的参数可以限制输出行的数量
    #
    # # 设置列不限制数量
    pd.set_option('display.max_columns', None)
    # # 最后的的参数可以限制输出列的数量
    #
    # # 设置value的显示长度为100，默认为50
    # pd.set_option('max_colwidth', 100)
    df1 = pd.DataFrame({
        "name": ["小明", "小红", "小孙", "王小", "关宇", "刘蓓", "张菲"],
        "age": [20, 18, 27, 20, 28, 18, 25],
        "sex": ["男", "女", "男", "男", "男", "女", "女"],
        "score": [669, 570, 642, 590, 601, 619, 701],
        "address": ["北京", "深圳", "广州", "武汉", "深圳", "广州", "长沙"]
    })
    # print(df1)
    csv = pd.read_csv("C:\RPA\前置机器人4\env.csv")
    date = pd.DataFrame(csv)
    pd.read_csv
    print(date["变量值"][0])
    # df2 = pd.read_excel("场景1输出_new.xlsx")
    # print('输出excel')
    # print(df2)
    print(df1["name"][1])
    # for i in df1["name"]:
    #     Basic.DebugOutput(self, i)


te = "test()"
exec(te)
ming =ce.person()
ming.tudo()

def getname(成绩数据表):
    姓名 = ''
    for name in 成绩数据表["B"]:
        if 姓名 == '':
            姓名 = name
            continue
        姓名 = 姓名 + "," + name
    return 姓名
    Basic.DebugOutput(self, 姓名)


data = "2023-01-03"
name = f"我来做霍安东风景就{data}分开了开始看看书"
print(name)

da = [
    [
        ['3月月考成绩单', None, None, None, None, None, None, None, None, None, None],
        ['序号', '姓名', '语文', '英语', '数学', '历史', '地理', '物理', '化学', '总分', '名次'],
        ['1', '王利奎', '67', '85', '63', '72', '57', '75', '58', '477', '1'],
        ['2', '杜娅琪', '67', '72', '85', '67', '58', '69', '54', '471', '2'],
        ['3', '牛震', '80', '65', '77', '43', '65', '88', '53', '470', '3'],
        ['4', '宋瑶', '43', '73', '81', '78', '52', '67', '68', '462', '4'],
        ['5', '韩妍妍', '51', '88', '82', '55', '41', '42', '75', '434', '5'],
        ['6', '李巧慧', '53', '69', '45', '42', '67', '71', '75', '422', '6'],
        ['7', '孙艺凡', '51', '78', '72', '60', '48', '64', '48', '421', '7'],
        ['8', '魏毓蕾', '60', '64', '68', '60', '54', '57', '57', '420', '8'],
        ['9', '魏庆蕊', '57', '49', '94', '62', '47', '58', '51', '418', '9'],
        ['10', '董梦毅', '46', '78', '70', '66', '56', '55', '39', '411', '10'],
        ['11', '许铖', '47', '42', '75', '80', '58', '61', '48', '411', '11'],
        ['12', '曹萌', '54', '75', '36', '61', '58', '69', '56', '409', '12'],
        ['13', '朱贺祥', '61', '30', '94', '60', '45', '68', '35', '393', '13'],
        ['14', '孟金景', '54.5', '70', '60', '42', '40', '62', '47', '375.5', '14'],
        ['15', '郭乃柄', '43', '54', '60', '62', '55', '49', '50', '373', '15'],
        ['16', '韩梦晴', '54', '72', '54', '62', '30', '37', '57', '366', '16'],
        ['17', '罗琳', '51', '73', '45', '58', '44', '55', '34', '360', '17'],
        ['18', '王梦威', '46', '49', '53', '54', '67', '46', '43', '358', '18'],
        ['19', '郝潇爽', '45', '57', '61', '60', '43', '45', '46', '357', '19'],
        ['20', '大王瑞娜', '54', '52', '26', '54', '46', '65', '56', '353', '20'],
        ['21', '刘园园', '43', '63', '53', '52', '32', '66', '37', '346', '21'],
        ['22', '王俊杰', '45', '62', '56', '44', '40', '54', '36', '338', '22'],
        ['23', '徐艺帆', '58', '57', '58', '54', '39', '29', '43', '338', '23'],
        ['24', '史婉玉', '45', '33', '91', '54', '30', '46', '38', '337', '24'],
        ['25', '李世文', '50', '54', '66', '50', '36', '35', '42', '333', '25'],
        ['26', '王晨雨', '53', '56', '62', '56', '29', '34', '36', '326', '26'],
        ['27', '王庆昆', '37', '53', '54', '52', '40', '31', '54', '321', '27'],
        ['28', '尚立艳', '52', '30', '45', '', '', '', '', '314', '28'],
        ['29', '陈梦娜', '58', '50', '35', '', '', '', '', '312', '29'],
        ['30', '李冬阳', '44', '67', '30', '', '', '', '', '308', '30'],
        ['31', '袁本科', '41', '38', '69', '46', '30', '45', '33', '302', '31'],
        ['32', '潘佳慧', '53', '56', '34', '48', '32', '50', '23', '296', '32'],
        ['33', '张梦茹', '38.5', '58', '23', '49', '44', '41', '42', '295.5', '33'],
        ['34', '祁雨露', '42', '46', '36', '54', '40', '43', '34', '295', '34'],
        ['35', '李晴', '52', '44', '26', '42', '38', '43', '48', '293', '35'],
        ['36', '蔡学智', '59', '27', '39', '62', '36', '28', '39', '290', '36']
    ],
    [
        ['37', '任智慧', '59', '32', '45', '50', '36', '24', '36', '282', '37'],
        ['38', '', '', '', '', '', '', '', '', '', ''],
        ['39', '', '', '', '', '', '', '', '', '', ''],
        ['40', '', '', '', '', '', '', '', '', '', ''],
        ['41', '', '', '', '', '', '', '', '', '', ''],
        ['42', '', '', '', '', '', '', '', '', '', ''],
        ['43', '', '', '', '', '', '', '', '', '', ''],
        ['44', '', '', '', '', '', '', '', '', '', ''],
        ['45', '', '', '', '', '', '', '', '', '', ''],
        ['46', '', '', '', '', '', '', '', '', '', ''],
        ['47', '', '', '', '', '', '', '', '', '', ''],
        ['48', '', '', '', '', '', '', '', '', '', '']
    ]
]

print(da)

a = [['80']]
print(a[0][0])
